package com.springboot.demo.mapper;
import com.springboot.demo.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import org.springframework.stereotype.Component;

@Component
@Mapper
@Repository
public interface LibrarianMapper {

    @Select("SELECT level FROM librarian where phone=#{phonenumber} and password=#{password}")
    String login(User user);

    @Select("SELECT lname FROM librarian where phone=#{phonenumber} and password=#{password}")
    String getName(User user);


}

